<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html>
<head>
<title>MySQL tutorial</title>
<link rel="stylesheet" href="/cfg/format.css" type="text/css">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="keywords" content="MySQL, database, tutorial, SQL, command line tool">
<meta name="description" content="This is MySQL tutorial. It covers the MySQL database engine and 
the SQL language supported by the database engine. ">
<meta name="language" content="en">
<meta name="author" content="Jan Bodnar">
<meta name="distribution" content="global">

<script type="text/javascript" src="/lib/jquery.js"></script>
<script type="text/javascript" src="/lib/common.js"></script>

<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>

<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-5536206-1']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
</head>

<body>

<div class="container">

<div id="wide_ad" class="ltow">
<script type="text/javascript"><!--
google_ad_client = "pub-9706709751191532";
/* 160x600, August 2011 */
google_ad_slot = "2484182563";
google_ad_width = 160;
google_ad_height = 600;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>


<div class="content">

<a href="/" title="Home">Home</a>

<h1>MySQL tutorial</h1>

<ol>

<li>
<a href="introduction/">Introduction</a>
<ol>
<li type="i"><a href="introduction#about">About this tutorial</a></li>
<li type="i"><a href="introduction#mysql">MySQL database</a></li>
<li type="i"><a href="introduction#definitions">Definitions</a></li>
<li type="i"><a href="introduction#tables">Tables used</a></li>
<li type="i"><a href="introduction#sources">Sources</a></li>
</ol>
</li>

<li>
<a href="installation/">Installation</a>
<ol>
<li type="i"><a href="installation#sources">Installation from sources</a></li>
<li type="i"><a href="installation#root">Changing the root password</a></li>
<li type="i"><a href="installation#other">Other settings</a></li>
</ol>
</li>

<li>
<a href="firststeps/">First steps</a>
<ol>
<li type="i"><a href="firststeps#startstop">Starting/stopping the server</a></li>
<li type="i"><a href="firststeps#connect">Connecting to the server</a></li>
<li type="i"><a href="firststeps#database">Creating a database</a></li>
<li type="i"><a href="firststeps#user">Creating a user</a></li>
</ol>
</li>

<li>
<a href="quick/">Quick MySQL tutorial</a>
<ol>
<li type="i"><a href="quick#world">The world database</a></li>
<li type="i"><a href="quick#examine">Examining the database</a></li>
<li type="i"><a href="quick#queries">Queries</a></li>
</ol>
</li>

<li>
<a href="storageengines/">Storage engines</a>
<ol>
<li type="i"><a href="storageengines#list">List of storage engines</a></li>
<li type="i"><a href="storageengines#choose">Choosing the right engine</a></li>
<li type="i"><a href="storageengines#specalt">Specifying and altering storage engines</a></li>
</ol>
</li>

<li>
<a href="datatypes/">Data types</a>
<ol>
<li type="i"><a href="datatypes#numbers">Numbers</a></li>
<li type="i"><a href="datatypes#datetime">Date &amp; time</a></li>
<li type="i"><a href="datatypes#strings">Strings</a></li>
</ol>
</li>

<li>
<a href="tables/">Creating, altering and dropping tables</a>
<ol>
<li type="i"><a href="tables#create">CREATE and DROP statements</a></li>
<li type="i"><a href="tables#alter">ALTER TABLE statement</a></li>
</ol>
</li>

<li>
<a href="expressions/">MySQL expressions</a>
<ol>
<li type="i"><a href="expressions#literal">Literal values</a></li>
<li type="i"><a href="expressions#variables">Variables</a></li>
<li type="i"><a href="expressions#operators">Operators</a></li>
<li type="i"><a href="expressions#precedence">Precedence and associativity</a></li>
<li type="i"><a href="expressions#associativity">Associativity</a></li>
</ol>
</li>

<li>
<a href="datamanipulation/">Inserting, updating and deleting data</a>
<ol>
<li type="i"><a href="datamanipulation#insert">Inserting data</a></li>
<li type="i"><a href="datamanipulation#delete">Deleting data</a></li>
<li type="i"><a href="datamanipulation#update">Updating data</a></li>
</ol>
</li>

<li>
<a href="select/">The SELECT statement</a>
<ol>
<li type="i"><a href="select#retrieve">Retrieving data</a></li>
<li type="i"><a href="select#limit">Limiting data output</a></li>
<li type="i"><a href="select#order">Ordering data</a></li>
<li type="i"><a href="select#where">Selecting specific rows with the WHERE clause</a></li>
<li type="i"><a href="select#remove">Removing duplicate items</a></li>
<li type="i"><a href="select#group">Grouping data</a></li>
</ol>
</li>

<li>
<a href="subqueries/">Subqueries</a>
</li>

<li>
<a href="constraints/">Constraints</a>
</li>

<li>
<a href="exportimport/">Exporting and importing data</a>
<ol>
<li type="i"><a href="exportimport#simple">Simple data export</a></li>
<li type="i"><a href="exportimport#xml">Exporting to xml files</a></li>
<li type="i"><a href="exportimport#dump">Using mysqldump tool</a></li>
</ol>
</li>

<li>
<a href="joins/">Joining tables</a>
<ol>
<li type="i"><a href="joins#inner">Inner joins</a></li>
<li type="i"><a href="joins#outer">Outer joins</a></li>
<li type="i"><a href="joins#natural">Natural joins</a></li>
<li type="i"><a href="joins#recap">Quick recap</a></li>
</ol>
</li>

<li>
<a href="functions/">MySQL functions</a>
<ol>
<li type="i"><a href="functions#math">Mathematical functions</a></li>
<li type="i"><a href="functions#aggregate">Aggregate functions</a></li>
<li type="i"><a href="functions#string">String functions</a></li>
<li type="i"><a href="functions#datetime">Date &amp; time functions</a></li>
<li type="i"><a href="functions#system">System functions</a></li>
</ol>
</li>

<li>
<a href="views/">Views</a>
<ol>
<li type="i"><a href="views#definition">View definition</a></li>
<li type="i"><a href="views#cmdv">Creating, modifying and dropping a view</a></li>
<li type="i"><a href="views#find">Finding views</a></li>
<li type="i"><a href="views#crun">Creating a view with a union</a></li>
</ol>
</li>

<li>
<a href="transactions/">Transactions</a>
<ol>
<li type="i"><a href="transactions#definition">Definition of transaction</a></li>
<li type="i"><a href="transactions#isolation">Isolation levels</a></li>
<li type="i"><a href="transactions#autocommit">Autocommit</a></li>
<li type="i"><a href="transactions#start">Starting transactions</a></li>
</ol>
</li>

<li>
<a href="routines/">Stored routines</a>
<ol>
<li type="i"><a href="routines#simproc">A simple procedure</a></li>
<li type="i"><a href="routines#simfunc">A simple function</a></li>
<li type="i"><a href="routines#procpar">Procedure parameters</a></li>
<li type="i"><a href="routines#rand">Random numbers</a></li>
<li type="i"><a href="routines#find">Finding routines</a></li>
</ol>
</li>

</ol>

<p style="width:500px">
This is MySQL tutorial.
It covers the MySQL database engine and 
the SQL language supported by the database engine.
</p>

<div class="g-plusone"></div>

<p>
Similar tutorials
<br>
<a href="/db/sqlite/">SQLite tutorial</a><br>
<a href="/tutorials/mysqlcapitutorial/">MySQL C API tutorial</a><br>
<a href="/databases/mysqlphptutorial/">MySQL PHP tutorial</a><br>
<a href="/databases/mysqlvisualbasictutorial/">MySQL Visual Basic tutorial</a><br>
<a href="/databases/mysqlpythontutorial/">MySQL Python tutorial</a><br>
<a href="/databases/mysqljavatutorial/">MySQL Java tutorial</a><br>
<a href="/db/mysqlperl/">MySQL Perl tutorial</a>
</p>


<div class="footer">
<div class="signature">
<a href="/">ZetCode::</a> last modified February 21, 2011 <span class="copyright">&copy; 2007 - 2013 Jan Bodnar</span>
</div>
</div>


</div> <!-- content -->

</div> <!-- container -->

</body>
</html>
